﻿CREATE TABLE [dbo].[CIMFirmInfo]
(
[aid] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[passDate] [datetime] NULL,
[terms] [smallint] NULL,
[termFrom] [datetime] NULL,
[sureConId] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[sureConNotarDate] [datetime] NULL,
[operatorName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[sepName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[dealMan] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[shenpiren1] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[shenpiren2] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[urge1] [datetime] NULL,
[urge2] [datetime] NULL,
[urge3] [datetime] NULL,
[urge4] [datetime] NULL,
[urge5] [datetime] NULL,
[lawFirmName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[lawyer] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[tel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[courtName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[judge] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[courTel] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[remark] [varchar] (5000) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]


